package com.pgybook.db.entity.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CustomerEx {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CustomerEx() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCustidIsNull() {
            addCriterion("CUSTID is null");
            return (Criteria) this;
        }

        public Criteria andCustidIsNotNull() {
            addCriterion("CUSTID is not null");
            return (Criteria) this;
        }

        public Criteria andCustidEqualTo(Long value) {
            addCriterion("CUSTID =", value, "custid");
            return (Criteria) this;
        }

        public Criteria andCustidNotEqualTo(Long value) {
            addCriterion("CUSTID <>", value, "custid");
            return (Criteria) this;
        }

        public Criteria andCustidGreaterThan(Long value) {
            addCriterion("CUSTID >", value, "custid");
            return (Criteria) this;
        }

        public Criteria andCustidGreaterThanOrEqualTo(Long value) {
            addCriterion("CUSTID >=", value, "custid");
            return (Criteria) this;
        }

        public Criteria andCustidLessThan(Long value) {
            addCriterion("CUSTID <", value, "custid");
            return (Criteria) this;
        }

        public Criteria andCustidLessThanOrEqualTo(Long value) {
            addCriterion("CUSTID <=", value, "custid");
            return (Criteria) this;
        }

        public Criteria andCustidIn(List<Long> values) {
            addCriterion("CUSTID in", values, "custid");
            return (Criteria) this;
        }

        public Criteria andCustidNotIn(List<Long> values) {
            addCriterion("CUSTID not in", values, "custid");
            return (Criteria) this;
        }

        public Criteria andCustidBetween(Long value1, Long value2) {
            addCriterion("CUSTID between", value1, value2, "custid");
            return (Criteria) this;
        }

        public Criteria andCustidNotBetween(Long value1, Long value2) {
            addCriterion("CUSTID not between", value1, value2, "custid");
            return (Criteria) this;
        }

        public Criteria andCustgradeidIsNull() {
            addCriterion("CUSTGRADEID is null");
            return (Criteria) this;
        }

        public Criteria andCustgradeidIsNotNull() {
            addCriterion("CUSTGRADEID is not null");
            return (Criteria) this;
        }

        public Criteria andCustgradeidEqualTo(Integer value) {
            addCriterion("CUSTGRADEID =", value, "custgradeid");
            return (Criteria) this;
        }

        public Criteria andCustgradeidNotEqualTo(Integer value) {
            addCriterion("CUSTGRADEID <>", value, "custgradeid");
            return (Criteria) this;
        }

        public Criteria andCustgradeidGreaterThan(Integer value) {
            addCriterion("CUSTGRADEID >", value, "custgradeid");
            return (Criteria) this;
        }

        public Criteria andCustgradeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("CUSTGRADEID >=", value, "custgradeid");
            return (Criteria) this;
        }

        public Criteria andCustgradeidLessThan(Integer value) {
            addCriterion("CUSTGRADEID <", value, "custgradeid");
            return (Criteria) this;
        }

        public Criteria andCustgradeidLessThanOrEqualTo(Integer value) {
            addCriterion("CUSTGRADEID <=", value, "custgradeid");
            return (Criteria) this;
        }

        public Criteria andCustgradeidIn(List<Integer> values) {
            addCriterion("CUSTGRADEID in", values, "custgradeid");
            return (Criteria) this;
        }

        public Criteria andCustgradeidNotIn(List<Integer> values) {
            addCriterion("CUSTGRADEID not in", values, "custgradeid");
            return (Criteria) this;
        }

        public Criteria andCustgradeidBetween(Integer value1, Integer value2) {
            addCriterion("CUSTGRADEID between", value1, value2, "custgradeid");
            return (Criteria) this;
        }

        public Criteria andCustgradeidNotBetween(Integer value1, Integer value2) {
            addCriterion("CUSTGRADEID not between", value1, value2, "custgradeid");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("EMAIL is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("EMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("EMAIL =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("EMAIL <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("EMAIL >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("EMAIL >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("EMAIL <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("EMAIL <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("EMAIL like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("EMAIL not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("EMAIL in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("EMAIL not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("EMAIL between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("EMAIL not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("PASSWORD is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("PASSWORD is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("PASSWORD =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("PASSWORD <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("PASSWORD >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("PASSWORD >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("PASSWORD <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("PASSWORD <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("PASSWORD like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("PASSWORD not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("PASSWORD in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("PASSWORD not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("PASSWORD between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("PASSWORD not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysIsNull() {
            addCriterion("BORROWDAYS is null");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysIsNotNull() {
            addCriterion("BORROWDAYS is not null");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysEqualTo(Integer value) {
            addCriterion("BORROWDAYS =", value, "borrowdays");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysNotEqualTo(Integer value) {
            addCriterion("BORROWDAYS <>", value, "borrowdays");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysGreaterThan(Integer value) {
            addCriterion("BORROWDAYS >", value, "borrowdays");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysGreaterThanOrEqualTo(Integer value) {
            addCriterion("BORROWDAYS >=", value, "borrowdays");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysLessThan(Integer value) {
            addCriterion("BORROWDAYS <", value, "borrowdays");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysLessThanOrEqualTo(Integer value) {
            addCriterion("BORROWDAYS <=", value, "borrowdays");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysIn(List<Integer> values) {
            addCriterion("BORROWDAYS in", values, "borrowdays");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysNotIn(List<Integer> values) {
            addCriterion("BORROWDAYS not in", values, "borrowdays");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysBetween(Integer value1, Integer value2) {
            addCriterion("BORROWDAYS between", value1, value2, "borrowdays");
            return (Criteria) this;
        }

        public Criteria andBorrowdaysNotBetween(Integer value1, Integer value2) {
            addCriterion("BORROWDAYS not between", value1, value2, "borrowdays");
            return (Criteria) this;
        }

        public Criteria andMobile1IsNull() {
            addCriterion("MOBILE1 is null");
            return (Criteria) this;
        }

        public Criteria andMobile1IsNotNull() {
            addCriterion("MOBILE1 is not null");
            return (Criteria) this;
        }

        public Criteria andMobile1EqualTo(String value) {
            addCriterion("MOBILE1 =", value, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1NotEqualTo(String value) {
            addCriterion("MOBILE1 <>", value, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1GreaterThan(String value) {
            addCriterion("MOBILE1 >", value, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1GreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE1 >=", value, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1LessThan(String value) {
            addCriterion("MOBILE1 <", value, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1LessThanOrEqualTo(String value) {
            addCriterion("MOBILE1 <=", value, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1Like(String value) {
            addCriterion("MOBILE1 like", value, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1NotLike(String value) {
            addCriterion("MOBILE1 not like", value, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1In(List<String> values) {
            addCriterion("MOBILE1 in", values, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1NotIn(List<String> values) {
            addCriterion("MOBILE1 not in", values, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1Between(String value1, String value2) {
            addCriterion("MOBILE1 between", value1, value2, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile1NotBetween(String value1, String value2) {
            addCriterion("MOBILE1 not between", value1, value2, "mobile1");
            return (Criteria) this;
        }

        public Criteria andMobile2IsNull() {
            addCriterion("MOBILE2 is null");
            return (Criteria) this;
        }

        public Criteria andMobile2IsNotNull() {
            addCriterion("MOBILE2 is not null");
            return (Criteria) this;
        }

        public Criteria andMobile2EqualTo(String value) {
            addCriterion("MOBILE2 =", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2NotEqualTo(String value) {
            addCriterion("MOBILE2 <>", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2GreaterThan(String value) {
            addCriterion("MOBILE2 >", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2GreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE2 >=", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2LessThan(String value) {
            addCriterion("MOBILE2 <", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2LessThanOrEqualTo(String value) {
            addCriterion("MOBILE2 <=", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2Like(String value) {
            addCriterion("MOBILE2 like", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2NotLike(String value) {
            addCriterion("MOBILE2 not like", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2In(List<String> values) {
            addCriterion("MOBILE2 in", values, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2NotIn(List<String> values) {
            addCriterion("MOBILE2 not in", values, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2Between(String value1, String value2) {
            addCriterion("MOBILE2 between", value1, value2, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2NotBetween(String value1, String value2) {
            addCriterion("MOBILE2 not between", value1, value2, "mobile2");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("PHONE is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("PHONE is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("PHONE =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("PHONE <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("PHONE >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("PHONE >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("PHONE <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("PHONE <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("PHONE like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("PHONE not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("PHONE in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("PHONE not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("PHONE between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("PHONE not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPrvidIsNull() {
            addCriterion("PRVID is null");
            return (Criteria) this;
        }

        public Criteria andPrvidIsNotNull() {
            addCriterion("PRVID is not null");
            return (Criteria) this;
        }

        public Criteria andPrvidEqualTo(Integer value) {
            addCriterion("PRVID =", value, "prvid");
            return (Criteria) this;
        }

        public Criteria andPrvidNotEqualTo(Integer value) {
            addCriterion("PRVID <>", value, "prvid");
            return (Criteria) this;
        }

        public Criteria andPrvidGreaterThan(Integer value) {
            addCriterion("PRVID >", value, "prvid");
            return (Criteria) this;
        }

        public Criteria andPrvidGreaterThanOrEqualTo(Integer value) {
            addCriterion("PRVID >=", value, "prvid");
            return (Criteria) this;
        }

        public Criteria andPrvidLessThan(Integer value) {
            addCriterion("PRVID <", value, "prvid");
            return (Criteria) this;
        }

        public Criteria andPrvidLessThanOrEqualTo(Integer value) {
            addCriterion("PRVID <=", value, "prvid");
            return (Criteria) this;
        }

        public Criteria andPrvidIn(List<Integer> values) {
            addCriterion("PRVID in", values, "prvid");
            return (Criteria) this;
        }

        public Criteria andPrvidNotIn(List<Integer> values) {
            addCriterion("PRVID not in", values, "prvid");
            return (Criteria) this;
        }

        public Criteria andPrvidBetween(Integer value1, Integer value2) {
            addCriterion("PRVID between", value1, value2, "prvid");
            return (Criteria) this;
        }

        public Criteria andPrvidNotBetween(Integer value1, Integer value2) {
            addCriterion("PRVID not between", value1, value2, "prvid");
            return (Criteria) this;
        }

        public Criteria andLibidIsNull() {
            addCriterion("LIBID is null");
            return (Criteria) this;
        }

        public Criteria andLibidIsNotNull() {
            addCriterion("LIBID is not null");
            return (Criteria) this;
        }

        public Criteria andLibidEqualTo(Integer value) {
            addCriterion("LIBID =", value, "libid");
            return (Criteria) this;
        }

        public Criteria andLibidNotEqualTo(Integer value) {
            addCriterion("LIBID <>", value, "libid");
            return (Criteria) this;
        }

        public Criteria andLibidGreaterThan(Integer value) {
            addCriterion("LIBID >", value, "libid");
            return (Criteria) this;
        }

        public Criteria andLibidGreaterThanOrEqualTo(Integer value) {
            addCriterion("LIBID >=", value, "libid");
            return (Criteria) this;
        }

        public Criteria andLibidLessThan(Integer value) {
            addCriterion("LIBID <", value, "libid");
            return (Criteria) this;
        }

        public Criteria andLibidLessThanOrEqualTo(Integer value) {
            addCriterion("LIBID <=", value, "libid");
            return (Criteria) this;
        }

        public Criteria andLibidIn(List<Integer> values) {
            addCriterion("LIBID in", values, "libid");
            return (Criteria) this;
        }

        public Criteria andLibidNotIn(List<Integer> values) {
            addCriterion("LIBID not in", values, "libid");
            return (Criteria) this;
        }

        public Criteria andLibidBetween(Integer value1, Integer value2) {
            addCriterion("LIBID between", value1, value2, "libid");
            return (Criteria) this;
        }

        public Criteria andLibidNotBetween(Integer value1, Integer value2) {
            addCriterion("LIBID not between", value1, value2, "libid");
            return (Criteria) this;
        }

        public Criteria andCustcodeIsNull() {
            addCriterion("CUSTCODE is null");
            return (Criteria) this;
        }

        public Criteria andCustcodeIsNotNull() {
            addCriterion("CUSTCODE is not null");
            return (Criteria) this;
        }

        public Criteria andCustcodeEqualTo(String value) {
            addCriterion("CUSTCODE =", value, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeNotEqualTo(String value) {
            addCriterion("CUSTCODE <>", value, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeGreaterThan(String value) {
            addCriterion("CUSTCODE >", value, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTCODE >=", value, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeLessThan(String value) {
            addCriterion("CUSTCODE <", value, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeLessThanOrEqualTo(String value) {
            addCriterion("CUSTCODE <=", value, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeLike(String value) {
            addCriterion("CUSTCODE like", value, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeNotLike(String value) {
            addCriterion("CUSTCODE not like", value, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeIn(List<String> values) {
            addCriterion("CUSTCODE in", values, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeNotIn(List<String> values) {
            addCriterion("CUSTCODE not in", values, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeBetween(String value1, String value2) {
            addCriterion("CUSTCODE between", value1, value2, "custcode");
            return (Criteria) this;
        }

        public Criteria andCustcodeNotBetween(String value1, String value2) {
            addCriterion("CUSTCODE not between", value1, value2, "custcode");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("NAME is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("NAME =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("NAME <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("NAME >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("NAME >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("NAME <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("NAME <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("NAME like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("NAME not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("NAME in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("NAME not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("NAME between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("NAME not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andAliasIsNull() {
            addCriterion("ALIAS is null");
            return (Criteria) this;
        }

        public Criteria andAliasIsNotNull() {
            addCriterion("ALIAS is not null");
            return (Criteria) this;
        }

        public Criteria andAliasEqualTo(String value) {
            addCriterion("ALIAS =", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotEqualTo(String value) {
            addCriterion("ALIAS <>", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasGreaterThan(String value) {
            addCriterion("ALIAS >", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasGreaterThanOrEqualTo(String value) {
            addCriterion("ALIAS >=", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasLessThan(String value) {
            addCriterion("ALIAS <", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasLessThanOrEqualTo(String value) {
            addCriterion("ALIAS <=", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasLike(String value) {
            addCriterion("ALIAS like", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotLike(String value) {
            addCriterion("ALIAS not like", value, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasIn(List<String> values) {
            addCriterion("ALIAS in", values, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotIn(List<String> values) {
            addCriterion("ALIAS not in", values, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasBetween(String value1, String value2) {
            addCriterion("ALIAS between", value1, value2, "alias");
            return (Criteria) this;
        }

        public Criteria andAliasNotBetween(String value1, String value2) {
            addCriterion("ALIAS not between", value1, value2, "alias");
            return (Criteria) this;
        }

        public Criteria andRecommemailIsNull() {
            addCriterion("RECOMMEMAIL is null");
            return (Criteria) this;
        }

        public Criteria andRecommemailIsNotNull() {
            addCriterion("RECOMMEMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andRecommemailEqualTo(String value) {
            addCriterion("RECOMMEMAIL =", value, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailNotEqualTo(String value) {
            addCriterion("RECOMMEMAIL <>", value, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailGreaterThan(String value) {
            addCriterion("RECOMMEMAIL >", value, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailGreaterThanOrEqualTo(String value) {
            addCriterion("RECOMMEMAIL >=", value, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailLessThan(String value) {
            addCriterion("RECOMMEMAIL <", value, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailLessThanOrEqualTo(String value) {
            addCriterion("RECOMMEMAIL <=", value, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailLike(String value) {
            addCriterion("RECOMMEMAIL like", value, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailNotLike(String value) {
            addCriterion("RECOMMEMAIL not like", value, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailIn(List<String> values) {
            addCriterion("RECOMMEMAIL in", values, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailNotIn(List<String> values) {
            addCriterion("RECOMMEMAIL not in", values, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailBetween(String value1, String value2) {
            addCriterion("RECOMMEMAIL between", value1, value2, "recommemail");
            return (Criteria) this;
        }

        public Criteria andRecommemailNotBetween(String value1, String value2) {
            addCriterion("RECOMMEMAIL not between", value1, value2, "recommemail");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountIsNull() {
            addCriterion("WEIBOACCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountIsNotNull() {
            addCriterion("WEIBOACCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountEqualTo(String value) {
            addCriterion("WEIBOACCOUNT =", value, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountNotEqualTo(String value) {
            addCriterion("WEIBOACCOUNT <>", value, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountGreaterThan(String value) {
            addCriterion("WEIBOACCOUNT >", value, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountGreaterThanOrEqualTo(String value) {
            addCriterion("WEIBOACCOUNT >=", value, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountLessThan(String value) {
            addCriterion("WEIBOACCOUNT <", value, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountLessThanOrEqualTo(String value) {
            addCriterion("WEIBOACCOUNT <=", value, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountLike(String value) {
            addCriterion("WEIBOACCOUNT like", value, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountNotLike(String value) {
            addCriterion("WEIBOACCOUNT not like", value, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountIn(List<String> values) {
            addCriterion("WEIBOACCOUNT in", values, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountNotIn(List<String> values) {
            addCriterion("WEIBOACCOUNT not in", values, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountBetween(String value1, String value2) {
            addCriterion("WEIBOACCOUNT between", value1, value2, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeiboaccountNotBetween(String value1, String value2) {
            addCriterion("WEIBOACCOUNT not between", value1, value2, "weiboaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountIsNull() {
            addCriterion("WEIXINACCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountIsNotNull() {
            addCriterion("WEIXINACCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountEqualTo(String value) {
            addCriterion("WEIXINACCOUNT =", value, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountNotEqualTo(String value) {
            addCriterion("WEIXINACCOUNT <>", value, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountGreaterThan(String value) {
            addCriterion("WEIXINACCOUNT >", value, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountGreaterThanOrEqualTo(String value) {
            addCriterion("WEIXINACCOUNT >=", value, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountLessThan(String value) {
            addCriterion("WEIXINACCOUNT <", value, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountLessThanOrEqualTo(String value) {
            addCriterion("WEIXINACCOUNT <=", value, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountLike(String value) {
            addCriterion("WEIXINACCOUNT like", value, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountNotLike(String value) {
            addCriterion("WEIXINACCOUNT not like", value, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountIn(List<String> values) {
            addCriterion("WEIXINACCOUNT in", values, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountNotIn(List<String> values) {
            addCriterion("WEIXINACCOUNT not in", values, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountBetween(String value1, String value2) {
            addCriterion("WEIXINACCOUNT between", value1, value2, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andWeixinaccountNotBetween(String value1, String value2) {
            addCriterion("WEIXINACCOUNT not between", value1, value2, "weixinaccount");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeIsNull() {
            addCriterion("LASTSUCCESSLOGINTIME is null");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeIsNotNull() {
            addCriterion("LASTSUCCESSLOGINTIME is not null");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeEqualTo(Date value) {
            addCriterion("LASTSUCCESSLOGINTIME =", value, "lastsuccesslogintime");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeNotEqualTo(Date value) {
            addCriterion("LASTSUCCESSLOGINTIME <>", value, "lastsuccesslogintime");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeGreaterThan(Date value) {
            addCriterion("LASTSUCCESSLOGINTIME >", value, "lastsuccesslogintime");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeGreaterThanOrEqualTo(Date value) {
            addCriterion("LASTSUCCESSLOGINTIME >=", value, "lastsuccesslogintime");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeLessThan(Date value) {
            addCriterion("LASTSUCCESSLOGINTIME <", value, "lastsuccesslogintime");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeLessThanOrEqualTo(Date value) {
            addCriterion("LASTSUCCESSLOGINTIME <=", value, "lastsuccesslogintime");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeIn(List<Date> values) {
            addCriterion("LASTSUCCESSLOGINTIME in", values, "lastsuccesslogintime");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeNotIn(List<Date> values) {
            addCriterion("LASTSUCCESSLOGINTIME not in", values, "lastsuccesslogintime");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeBetween(Date value1, Date value2) {
            addCriterion("LASTSUCCESSLOGINTIME between", value1, value2, "lastsuccesslogintime");
            return (Criteria) this;
        }

        public Criteria andLastsuccesslogintimeNotBetween(Date value1, Date value2) {
            addCriterion("LASTSUCCESSLOGINTIME not between", value1, value2, "lastsuccesslogintime");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountIsNull() {
            addCriterion("LOGINFAILCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountIsNotNull() {
            addCriterion("LOGINFAILCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountEqualTo(Integer value) {
            addCriterion("LOGINFAILCOUNT =", value, "loginfailcount");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountNotEqualTo(Integer value) {
            addCriterion("LOGINFAILCOUNT <>", value, "loginfailcount");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountGreaterThan(Integer value) {
            addCriterion("LOGINFAILCOUNT >", value, "loginfailcount");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountGreaterThanOrEqualTo(Integer value) {
            addCriterion("LOGINFAILCOUNT >=", value, "loginfailcount");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountLessThan(Integer value) {
            addCriterion("LOGINFAILCOUNT <", value, "loginfailcount");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountLessThanOrEqualTo(Integer value) {
            addCriterion("LOGINFAILCOUNT <=", value, "loginfailcount");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountIn(List<Integer> values) {
            addCriterion("LOGINFAILCOUNT in", values, "loginfailcount");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountNotIn(List<Integer> values) {
            addCriterion("LOGINFAILCOUNT not in", values, "loginfailcount");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountBetween(Integer value1, Integer value2) {
            addCriterion("LOGINFAILCOUNT between", value1, value2, "loginfailcount");
            return (Criteria) this;
        }

        public Criteria andLoginfailcountNotBetween(Integer value1, Integer value2) {
            addCriterion("LOGINFAILCOUNT not between", value1, value2, "loginfailcount");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceIsNull() {
            addCriterion("BOOKCOINREWARDACCTBALANCE is null");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceIsNotNull() {
            addCriterion("BOOKCOINREWARDACCTBALANCE is not null");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceEqualTo(BigDecimal value) {
            addCriterion("BOOKCOINREWARDACCTBALANCE =", value, "bookcoinrewardacctbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceNotEqualTo(BigDecimal value) {
            addCriterion("BOOKCOINREWARDACCTBALANCE <>", value, "bookcoinrewardacctbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceGreaterThan(BigDecimal value) {
            addCriterion("BOOKCOINREWARDACCTBALANCE >", value, "bookcoinrewardacctbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BOOKCOINREWARDACCTBALANCE >=", value, "bookcoinrewardacctbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceLessThan(BigDecimal value) {
            addCriterion("BOOKCOINREWARDACCTBALANCE <", value, "bookcoinrewardacctbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BOOKCOINREWARDACCTBALANCE <=", value, "bookcoinrewardacctbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceIn(List<BigDecimal> values) {
            addCriterion("BOOKCOINREWARDACCTBALANCE in", values, "bookcoinrewardacctbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceNotIn(List<BigDecimal> values) {
            addCriterion("BOOKCOINREWARDACCTBALANCE not in", values, "bookcoinrewardacctbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BOOKCOINREWARDACCTBALANCE between", value1, value2, "bookcoinrewardacctbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinrewardacctbalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BOOKCOINREWARDACCTBALANCE not between", value1, value2, "bookcoinrewardacctbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceIsNull() {
            addCriterion("BOOKCOINACCTCASHBALANCE is null");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceIsNotNull() {
            addCriterion("BOOKCOINACCTCASHBALANCE is not null");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceEqualTo(BigDecimal value) {
            addCriterion("BOOKCOINACCTCASHBALANCE =", value, "bookcoinacctcashbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceNotEqualTo(BigDecimal value) {
            addCriterion("BOOKCOINACCTCASHBALANCE <>", value, "bookcoinacctcashbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceGreaterThan(BigDecimal value) {
            addCriterion("BOOKCOINACCTCASHBALANCE >", value, "bookcoinacctcashbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BOOKCOINACCTCASHBALANCE >=", value, "bookcoinacctcashbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceLessThan(BigDecimal value) {
            addCriterion("BOOKCOINACCTCASHBALANCE <", value, "bookcoinacctcashbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BOOKCOINACCTCASHBALANCE <=", value, "bookcoinacctcashbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceIn(List<BigDecimal> values) {
            addCriterion("BOOKCOINACCTCASHBALANCE in", values, "bookcoinacctcashbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceNotIn(List<BigDecimal> values) {
            addCriterion("BOOKCOINACCTCASHBALANCE not in", values, "bookcoinacctcashbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BOOKCOINACCTCASHBALANCE between", value1, value2, "bookcoinacctcashbalance");
            return (Criteria) this;
        }

        public Criteria andBookcoinacctcashbalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BOOKCOINACCTCASHBALANCE not between", value1, value2, "bookcoinacctcashbalance");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceIsNull() {
            addCriterion("DEPOSITBALANCE is null");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceIsNotNull() {
            addCriterion("DEPOSITBALANCE is not null");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceEqualTo(BigDecimal value) {
            addCriterion("DEPOSITBALANCE =", value, "depositbalance");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceNotEqualTo(BigDecimal value) {
            addCriterion("DEPOSITBALANCE <>", value, "depositbalance");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceGreaterThan(BigDecimal value) {
            addCriterion("DEPOSITBALANCE >", value, "depositbalance");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DEPOSITBALANCE >=", value, "depositbalance");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceLessThan(BigDecimal value) {
            addCriterion("DEPOSITBALANCE <", value, "depositbalance");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DEPOSITBALANCE <=", value, "depositbalance");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceIn(List<BigDecimal> values) {
            addCriterion("DEPOSITBALANCE in", values, "depositbalance");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceNotIn(List<BigDecimal> values) {
            addCriterion("DEPOSITBALANCE not in", values, "depositbalance");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DEPOSITBALANCE between", value1, value2, "depositbalance");
            return (Criteria) this;
        }

        public Criteria andDepositbalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DEPOSITBALANCE not between", value1, value2, "depositbalance");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}